﻿// =================================================================== 
// 项目说明
//====================================================================

// ===================================================================
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using CommonLib.Model;


namespace CommonLib.IDAL
{
    public interface ICommLibStoreProcedureDAL
    {
        Int32 GETNEWIDFORCODE(string _MAT_NO);
        Int32 LeadBidder(string _Bidder_ID);
		string FNYX_GETPRICEINFO(string OLTAGEID,string RICEKINDID);
		Int32 GETNEWIDFORMAT(string _NAME,string _TABLE,string _FIELD,string UR_FORMAT);
		Int32 GETNEWIDFORTABLE(string _NAME,string _TABLE,string _FIELD);
		void PROC_GETNEWIDFORTABLEBATCH(string ABNAME,string _FIELD,Int32 DDCOUNT,ref Int32 EWID_VAR);
        Int32 PROC_CREATEFEEMONTHINOUTRPT(string _STOREROOMID, string _FEEMONTH, string _START_TIME, string _END_TIME, string _CREATOR);
        Int32 PROC_CreateFeeMonthUseRpt(string _STOREROOMID, string _FEEMONTH, string _START_TIME, string _END_TIME, string _CREATOR, string _MAIN_DEPT);

		string FNYX_GETPRICEINFO(DBTransaction dbTrans,string OLTAGEID,string RICEKINDID);
		Int32 GETNEWIDFORMAT(DBTransaction dbTrans,string _NAME,string _TABLE,string _FIELD,string UR_FORMAT);
		Int32 GETNEWIDFORTABLE(DBTransaction dbTrans,string _NAME,string _TABLE,string _FIELD);
		void PROC_GETNEWIDFORTABLEBATCH(DBTransaction dbTrans,string ABNAME,string _FIELD,Int32 DDCOUNT,ref Int32 EWID_VAR);

        Int32 PROC_GETNEWSNFORTABLE2(string _NAME, string _TABLE, string _FIELD, string UR_FORMAT);

        string GetNewSNForTableWithNewid(string Charge_No, int Begin_Id);

        string RunProcess(string Condations, int FeePay_id, string FEEPAY_NO, string apply_user, decimal feepay_money, string feepay_note);

        string DeleteFeepay(int FeePay_id);

        int CreateDeptCheckMonthRptByMode(int storeroom_id, string checkmonth, string start_time, string end_time, string creator);
        DataSet ExecPro(DataTable dt, string Pname);
	}
}
  

